The investor's portfolio example information is stored in a H2 database and "current" stock prices are stored in a delimited text file. When the VDB is completed, a single query will cause Teiid to access the relational and non-relational sources, calculate the portfolio values, and return the results.
-
Step-1: Setup Data Sources
-
Step-3: Building a VDB
-
Step-4: VDB Deployment
-
Step-5: Connecting to a VDB through JDBC
H2 database is used here since it is Open Source and comes with JBoss AS and is light-weight. You can substitute any other relational database, as long as you have a suitable JDBC driver. The schema file provided, and described below, is specific to H2, but can be easily converted for use with other databases.